Excel 2003 - Using Formulas, Referencing, Functions and Ranges

      The "Excel 2003 - Using Formulas, Referencing, Functions and Ranges" lesson covers the following topics:
  • Formulas and Referencing
  • Working with Functions
  • Working with Ranges
     
      Formulas and Referencing      
      Upon successful completion you will be able to:

1. Identify Formula Operators;
2. Enter Formulas;
3. Copy Formulas;
4. Apply the AutoFill Feature;
5. Update Formula Results;
6. Work with Absolute References;
7. Apply a Percentage Value.
     
      Working with Functions      
      Upon successful completion you will be able to:

1. Identify Function Components;
2. Enter Functions;
3. Use the AutoSum Button;
4. Apply the IF Function.
     
      Working with Ranges      
      Upon successful completion you will be able to:

1. Name Cells;
2. Name Ranges;
3. Move to Named Cells with Go To Box;
4. Navigate Ranges with the Name Box;
5. Use the Range Finder Feature.
     
This course can be purchased either individaully or as part of a package.
Single Training Course - Excel 2003 - Using Formulas, Referencing, Functions and Ranges :
Program Training Courses - Microsoft Excel 2003 :
Office Suite Training Courses - Microsoft Office 2003 :
© 2017 Online Training Masters